Overview

Dataset statistics

Number of variables45
Number of observations170023
Missing cells81976
Missing cells (%)1.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory57.2 MiB
Average record size in memory353.0 B

Variable types

CAT22
NUM16
BOOL7

Reproduction

Analysis started2020-07-09 17:35:18.742143
Analysis finished2020-07-09 17:36:43.297725
Duration1 minute and 24.56 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

STREET_NAME has a high cardinality: 1341 distinct values High cardinality
BEAT_OF_OCCURRENCE has a high cardinality: 271 distinct values High cardinality
LONGITUDE is highly correlated with LATITUDEHigh correlation
LATITUDE is highly correlated with LONGITUDEHigh correlation
MAIN_CAUSE is highly correlated with PRIM_CONTRIBUTORY_CAUSEHigh correlation
PRIM_CONTRIBUTORY_CAUSE is highly correlated with MAIN_CAUSEHigh correlation
LANE_TYPE has 81976 (48.2%) missing values Missing
LATITUDE is highly skewed (γ1 = -94.06388966) Skewed
LONGITUDE is highly skewed (γ1 = 99.32443394) Skewed
df_index has unique values Unique
CRASH_RECORD_ID has unique values Unique
RD_NO has unique values Unique
POSTED_SPEED_LIMIT has 2351 (1.4%) zeros Zeros
INJURIES_TOTAL has 147605 (86.8%) zeros Zeros
INJURIES_INCAPACITATING has 167295 (98.4%) zeros Zeros
INJURIES_NON_INCAPACITATING has 157578 (92.7%) zeros Zeros
INJURIES_REPORTED_NOT_EVIDENT has 161617 (95.1%) zeros Zeros
INJURIES_NO_INDICATION has 2783 (1.6%) zeros Zeros
CRASH_HOUR has 2664 (1.6%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

UNIQUE

Distinct count170023
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean212170.16976526706
Minimum6
Maximum416193
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum6
5-th percentile28454.4
Q1110251
median212739
Q3314676.5
95-th percentile395658.8
Maximum416193
Range416187
Interquartile range (IQR)204425.5

Descriptive statistics

Standard deviation118096.4642
Coefficient of variation (CV)0.5566120079
Kurtosis-1.191279946
Mean212170.1698
Median Absolute Deviation (MAD)102229
Skewness-0.01242153214
Sum3.607380877e+10
Variance1.394677486e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2641911< 0.1%
 
771991< 0.1%
 
690031< 0.1%
 
3352411< 0.1%
 
710481< 0.1%
 
3324361< 0.1%
 
3536701< 0.1%
 
976691< 0.1%
 
956201< 0.1%
 
833301< 0.1%
 
Other values (170013)170013> 99.9%
 
ValueCountFrequency (%) 
61< 0.1%
 
81< 0.1%
 
111< 0.1%
 
121< 0.1%
 
131< 0.1%
 
ValueCountFrequency (%) 
4161931< 0.1%
 
4161911< 0.1%
 
4161871< 0.1%
 
4161851< 0.1%
 
4161841< 0.1%
 

CRASH_RECORD_ID
Categorical

UNIQUE

Distinct count170023
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
0369378756c36e5cf3e326082c410ed564f44eed3b2bdd7c4569fd5434c10c5cd8c9eff26cee6ac80f9323612c8b05635d411d6811c8d58f51a32905a84b1a8f
 
1
65b898b3cd7fe07982a0961eafa7e15846934aab7bdefef1e4dd28223558766c75d54f743de04e9922a65205251a65cba98475c19b47728512f0ad6edac4b82d
 
1
b8308bbe775a21dc80a505c058af6c733a05c999500fb7778dfa6a1c69a8ddc45dff9b7bb930ac005dfade4ca520d9c32a55271d5c79d8da218d2eebe15d637f
 
1
8d912c9ef59f64ac63e12b9ce41a50177a7e4d458c194ccdc15fcaab4477d4e88b221912ae9dbc9ced56fd55cebb2fd46e2a10b6169e6512b9c6af8eb7807c04
 
1
8cb5dac0a8f4c6fbfb22a00021e2464e192acbfb54596c3485d4c348e902c066d66b55dadee3dd2463c6f4b010ffdbec69f34270c67e56746ff37945bd5c4c89
 
1
Other values (170018)
170018
ValueCountFrequency (%) 
0369378756c36e5cf3e326082c410ed564f44eed3b2bdd7c4569fd5434c10c5cd8c9eff26cee6ac80f9323612c8b05635d411d6811c8d58f51a32905a84b1a8f1< 0.1%
 
65b898b3cd7fe07982a0961eafa7e15846934aab7bdefef1e4dd28223558766c75d54f743de04e9922a65205251a65cba98475c19b47728512f0ad6edac4b82d1< 0.1%
 
b8308bbe775a21dc80a505c058af6c733a05c999500fb7778dfa6a1c69a8ddc45dff9b7bb930ac005dfade4ca520d9c32a55271d5c79d8da218d2eebe15d637f1< 0.1%
 
8d912c9ef59f64ac63e12b9ce41a50177a7e4d458c194ccdc15fcaab4477d4e88b221912ae9dbc9ced56fd55cebb2fd46e2a10b6169e6512b9c6af8eb7807c041< 0.1%
 
8cb5dac0a8f4c6fbfb22a00021e2464e192acbfb54596c3485d4c348e902c066d66b55dadee3dd2463c6f4b010ffdbec69f34270c67e56746ff37945bd5c4c891< 0.1%
 
2d2c0ab8950e029238e02e6ec4d8b83b614a557ee51bed49df04a1a364f060139a8b3c4ccd29599b71b0aeb54439f4e195b78b29ec3a3ac2c12e6beb784915c21< 0.1%
 
e31dfcdb25c3d1a90b2fc9850a5f618601c6359fd1ebf915dcec0c36836ba0a09c926cf50fee2108c114c5bd0565e61ceed084f7192e2d9e21ebb66aff30531c1< 0.1%
 
a2957d935da9b3c8d7a6d447d3d60ef747bc37fb61dc4f3feaa36378737d0877c9b84f6e1aa48f731725a14dfd3976a5d17907027230ee1a8e4d10ac906e3a111< 0.1%
 
a22e6631f1f17fe980b99a82f5db0eccb3175c02f6eb27b86e4133757c7349763e8f2a7d9958b7a20b17e888d503139eda30544f1460a9d3cf049a28bf9d132a1< 0.1%
 
fc93b7f28f4b387780c0c620734a58d168954d3208eceebc8d1c6d36616f796c864bbf35dabbca4341b90cc8e9feeef3b0d5d879b7a57749f916c8f52a0107ae1< 0.1%
 
Other values (170013)170013> 99.9%
 

Length

Max length128
Median length128
Mean length128
Min length128

RD_NO
Categorical

UNIQUE

Distinct count170023
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
JC565912
 
1
JC428556
 
1
JA398424
 
1
JC174948
 
1
JB550813
 
1
Other values (170018)
170018
ValueCountFrequency (%) 
JC5659121< 0.1%
 
JC4285561< 0.1%
 
JA3984241< 0.1%
 
JC1749481< 0.1%
 
JB5508131< 0.1%
 
JA5367801< 0.1%
 
JC2361421< 0.1%
 
JC2633151< 0.1%
 
JC5536591< 0.1%
 
HZ5481791< 0.1%
 
Other values (170013)170013> 99.9%
 

Length

Max length8
Median length8
Mean length8
Min length8

POSTED_SPEED_LIMIT
Real number (ℝ≥0)

ZEROS

Distinct count14
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.67997270957459
Minimum0.0
Maximum70.0
Zeros2351
Zeros (%)1.4%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile15
Q130
median30
Q330
95-th percentile35
Maximum70
Range70
Interquartile range (IQR)0

Descriptive statistics

Standard deviation6.125015883
Coefficient of variation (CV)0.2135642159
Kurtosis8.292285248
Mean28.67997271
Median Absolute Deviation (MAD)0
Skewness-2.307732956
Sum4876255
Variance37.51581957
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3012913976.0%
 
35120977.1%
 
2587675.2%
 
2054003.2%
 
1552173.1%
 
1025861.5%
 
023511.4%
 
4019301.1%
 
4512120.7%
 
511410.7%
 
Other values (4)1830.1%
 
ValueCountFrequency (%) 
023511.4%
 
511410.7%
 
1025861.5%
 
1552173.1%
 
2054003.2%
 
ValueCountFrequency (%) 
701< 0.1%
 
6010< 0.1%
 
551370.1%
 
5035< 0.1%
 
4512120.7%
 
Distinct count19
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
NO CONTROLS
88229
TRAFFIC SIGNAL
55468
STOP SIGN/FLASHER
20314
UNKNOWN
 
3110
OTHER
 
1026
Other values (14)
 
1876
ValueCountFrequency (%) 
NO CONTROLS8822951.9%
 
TRAFFIC SIGNAL5546832.6%
 
STOP SIGN/FLASHER2031411.9%
 
UNKNOWN31101.8%
 
OTHER10260.6%
 
LANE USE MARKING6290.4%
 
YIELD3090.2%
 
OTHER WARNING SIGN2180.1%
 
OTHER REG. SIGN2100.1%
 
RAILROAD CROSSING GATE1350.1%
 
Other values (9)3750.2%
 

Length

Max length24
Median length11
Mean length12.62965011
Min length5

DEVICE_CONDITION
Categorical

Distinct count8
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
NO CONTROLS
89998
FUNCTIONING PROPERLY
70609
UNKNOWN
 
6243
OTHER
 
1360
FUNCTIONING IMPROPERLY
 
1117
Other values (3)
 
696
ValueCountFrequency (%) 
NO CONTROLS8999852.9%
 
FUNCTIONING PROPERLY7060941.5%
 
UNKNOWN62433.7%
 
OTHER13600.8%
 
FUNCTIONING IMPROPERLY11170.7%
 
NOT FUNCTIONING5530.3%
 
WORN REFLECTIVE MATERIAL1140.1%
 
MISSING29< 0.1%
 

Length

Max length24
Median length11
Mean length14.636061
Min length5
Distinct count11
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
CLEAR
135513
RAIN
 
17503
SNOW
 
7254
CLOUDY/OVERCAST
 
6135
UNKNOWN
 
2174
Other values (6)
 
1444
ValueCountFrequency (%) 
CLEAR13551379.7%
 
RAIN1750310.3%
 
SNOW72544.3%
 
CLOUDY/OVERCAST61353.6%
 
UNKNOWN21741.3%
 
OTHER5590.3%
 
FOG/SMOKE/HAZE3530.2%
 
SLEET/HAIL3060.2%
 
FREEZING RAIN/DRIZZLE1560.1%
 
SEVERE CROSS WIND GATE46< 0.1%
 

Length

Max length22
Median length5
Mean length5.288749169
Min length4
Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
DAYLIGHT
117230
DARKNESS, LIGHTED ROAD
35379
DARKNESS
 
7452
DUSK
 
5267
DAWN
 
2971
ValueCountFrequency (%) 
DAYLIGHT11723068.9%
 
DARKNESS, LIGHTED ROAD3537920.8%
 
DARKNESS74524.4%
 
DUSK52673.1%
 
DAWN29711.7%
 
UNKNOWN17241.0%
 

Length

Max length22
Median length8
Mean length10.70922169
Min length4

FIRST_CRASH_TYPE
Categorical

Distinct count18
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
REAR END
52403
SIDESWIPE SAME DIRECTION
31505
TURNING
23259
PARKED MOTOR VEHICLE
22195
ANGLE
22150
Other values (13)
18511
ValueCountFrequency (%) 
REAR END5240330.8%
 
SIDESWIPE SAME DIRECTION3150518.5%
 
TURNING2325913.7%
 
PARKED MOTOR VEHICLE2219513.1%
 
ANGLE2215013.0%
 
FIXED OBJECT54613.2%
 
PEDESTRIAN35662.1%
 
SIDESWIPE OPPOSITE DIRECTION25691.5%
 
PEDALCYCLIST22141.3%
 
HEAD ON16130.9%
 
Other values (8)30881.8%
 

Length

Max length28
Median length8
Mean length12.60164801
Min length5

TRAFFICWAY_TYPE
Categorical

Distinct count20
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
NOT DIVIDED
76991
DIVIDED - W/MEDIAN (NOT RAISED)
35361
ONE-WAY
19075
DIVIDED - W/MEDIAN BARRIER
 
12003
PARKING LOT
 
9926
Other values (15)
16667
ValueCountFrequency (%) 
NOT DIVIDED7699145.3%
 
DIVIDED - W/MEDIAN (NOT RAISED)3536120.8%
 
ONE-WAY1907511.2%
 
DIVIDED - W/MEDIAN BARRIER120037.1%
 
PARKING LOT99265.8%
 
OTHER49062.9%
 
FOUR WAY40512.4%
 
ALLEY22681.3%
 
CENTER TURN LANE17331.0%
 
UNKNOWN10920.6%
 
Other values (10)26171.5%
 

Length

Max length31
Median length11
Mean length15.47732366
Min length4
Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
DRY
128493
WET
26900
SNOW OR SLUSH
 
6743
UNKNOWN
 
5774
ICE
 
1689
Other values (2)
 
424
ValueCountFrequency (%) 
DRY12849375.6%
 
WET2690015.8%
 
SNOW OR SLUSH67434.0%
 
UNKNOWN57743.4%
 
ICE16891.0%
 
OTHER3350.2%
 
SAND, MUD, DIRT890.1%
 

Length

Max length15
Median length3
Mean length3.542655994
Min length3

ROAD_DEFECT
Categorical

Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
NO DEFECTS
146325
UNKNOWN
 
20131
RUT, HOLES
 
1242
OTHER
 
1052
WORN SURFACE
 
706
Other values (2)
 
567
ValueCountFrequency (%) 
NO DEFECTS14632586.1%
 
UNKNOWN2013111.8%
 
RUT, HOLES12420.7%
 
OTHER10520.6%
 
WORN SURFACE7060.4%
 
SHOULDER DEFECT4000.2%
 
DEBRIS ON ROADWAY1670.1%
 

Length

Max length17
Median length10
Mean length9.640801539
Min length5

REPORT_TYPE
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
NOT ON SCENE (DESK REPORT)
98971
ON SCENE
71052
ValueCountFrequency (%) 
NOT ON SCENE (DESK REPORT)9897158.2%
 
ON SCENE7105241.8%
 

Length

Max length26
Median length26
Mean length18.47786476
Min length8

CRASH_TYPE
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
NO INJURY / DRIVE AWAY
127310
INJURY AND / OR TOW DUE TO CRASH
42713
ValueCountFrequency (%) 
NO INJURY / DRIVE AWAY12731074.9%
 
INJURY AND / OR TOW DUE TO CRASH4271325.1%
 

Length

Max length32
Median length22
Mean length24.51218953
Min length22
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
0
135422
1
34601
ValueCountFrequency (%) 
013542279.6%
 
13460120.4%
 

DAMAGE
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
OVER $1,500
99753
$501 - $1,500
48427
$500 OR LESS
21843
ValueCountFrequency (%) 
OVER $1,5009975358.7%
 
$501 - $1,5004842728.5%
 
$500 OR LESS2184312.8%
 

Length

Max length13
Median length11
Mean length11.6981232
Min length11

PRIM_CONTRIBUTORY_CAUSE
Categorical

HIGH CORRELATION

Distinct count33
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
FOLLOWING TOO CLOSELY
36010
FAILING TO YIELD RIGHT-OF-WAY
35339
IMPROPER OVERTAKING/PASSING
15747
IMPROPER BACKING
14179
IMPROPER LANE USAGE
12920
Other values (28)
55828
ValueCountFrequency (%) 
FOLLOWING TOO CLOSELY3601021.2%
 
FAILING TO YIELD RIGHT-OF-WAY3533920.8%
 
IMPROPER OVERTAKING/PASSING157479.3%
 
IMPROPER BACKING141798.3%
 
IMPROPER LANE USAGE129207.6%
 
FAILING TO REDUCE SPEED TO AVOID CRASH124877.3%
 
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE96785.7%
 
WEATHER50032.9%
 
DISREGARDING TRAFFIC SIGNALS48222.8%
 
DISREGARDING STOP SIGN31701.9%
 
Other values (23)2066812.2%
 

Length

Max length80
Median length27
Mean length27.14715068
Min length6
Distinct count40
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
NOT APPLICABLE
64854
UNABLE TO DETERMINE
38816
FAILING TO REDUCE SPEED TO AVOID CRASH
 
12053
FOLLOWING TOO CLOSELY
 
8748
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE
 
8659
Other values (35)
36893
ValueCountFrequency (%) 
NOT APPLICABLE6485438.1%
 
UNABLE TO DETERMINE3881622.8%
 
FAILING TO REDUCE SPEED TO AVOID CRASH120537.1%
 
FOLLOWING TOO CLOSELY87485.1%
 
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE86595.1%
 
FAILING TO YIELD RIGHT-OF-WAY84615.0%
 
IMPROPER OVERTAKING/PASSING42792.5%
 
IMPROPER LANE USAGE38732.3%
 
WEATHER35782.1%
 
IMPROPER BACKING26151.5%
 
Other values (30)140878.3%
 

Length

Max length80
Median length19
Mean length21.33806603
Min length6

STREET_NO
Real number (ℝ≥0)

Distinct count9237
Unique (%)5.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3569.368708939379
Minimum1.0
Maximum13799.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1
5-th percentile128
Q11158
median3100
Q35500
95-th percentile8700
Maximum13799
Range13798
Interquartile range (IQR)4342

Descriptive statistics

Standard deviation2810.179625
Coefficient of variation (CV)0.7873043817
Kurtosis0.004114620722
Mean3569.368709
Median Absolute Deviation (MAD)2120
Skewness0.7582665448
Sum606874776
Variance7897109.522
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10012820.8%
 
160011250.7%
 
20010770.6%
 
30010730.6%
 
80010650.6%
 
50010050.6%
 
24009250.5%
 
6009050.5%
 
12008900.5%
 
63008840.5%
 
Other values (9227)15979294.0%
 
ValueCountFrequency (%) 
16350.4%
 
23490.2%
 
364< 0.1%
 
440< 0.1%
 
5930.1%
 
ValueCountFrequency (%) 
137991< 0.1%
 
137705< 0.1%
 
137581< 0.1%
 
137561< 0.1%
 
137551< 0.1%
 

STREET_DIRECTION
Categorical

Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
W
61742
S
54254
N
42646
E
 
11381
ValueCountFrequency (%) 
W6174236.3%
 
S5425431.9%
 
N4264625.1%
 
E113816.7%
 

Length

Max length1
Median length1
Mean length1
Min length1

STREET_NAME
Categorical

HIGH CARDINALITY

Distinct count1341
Unique (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
WESTERN AVE
 
4876
PULASKI RD
 
4295
CICERO AVE
 
4041
ASHLAND AVE
 
3806
HALSTED ST
 
3500
Other values (1336)
149505
ValueCountFrequency (%) 
WESTERN AVE48762.9%
 
PULASKI RD42952.5%
 
CICERO AVE40412.4%
 
ASHLAND AVE38062.2%
 
HALSTED ST35002.1%
 
KEDZIE AVE28841.7%
 
MICHIGAN AVE25491.5%
 
STATE ST22831.3%
 
CLARK ST22411.3%
 
NORTH AVE21251.2%
 
Other values (1331)13742380.8%
 

Length

Max length27
Median length10
Mean length10.69305329
Min length5

BEAT_OF_OCCURRENCE
Categorical

HIGH CARDINALITY

Distinct count271
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
1834.0
 
2490
114.0
 
2363
122.0
 
2273
1831.0
 
1869
813.0
 
1690
Other values (266)
159338
ValueCountFrequency (%) 
1834.024901.5%
 
114.023631.4%
 
122.022731.3%
 
1831.018691.1%
 
813.016901.0%
 
815.016811.0%
 
2512.014240.8%
 
1622.014210.8%
 
833.014140.8%
 
834.013740.8%
 
Other values (261)15202489.4%
 

Length

Max length6
Median length6
Mean length5.593560871
Min length5

NUM_UNITS
Real number (ℝ≥0)

Distinct count12
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0433000241143846
Minimum1.0
Maximum12.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1
5-th percentile2
Q12
median2
Q32
95-th percentile3
Maximum12
Range11
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.3995417469
Coefficient of variation (CV)0.1955374846
Kurtosis33.41500969
Mean2.043300024
Median Absolute Deviation (MAD)0
Skewness3.370232641
Sum347408
Variance0.1596336075
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
215253789.7%
 
391825.4%
 
163673.7%
 
414910.9%
 
53130.2%
 
685< 0.1%
 
721< 0.1%
 
816< 0.1%
 
97< 0.1%
 
112< 0.1%
 
Other values (2)2< 0.1%
 
ValueCountFrequency (%) 
163673.7%
 
215253789.7%
 
391825.4%
 
414910.9%
 
53130.2%
 
ValueCountFrequency (%) 
121< 0.1%
 
112< 0.1%
 
101< 0.1%
 
97< 0.1%
 
816< 0.1%
 

INJURIES_TOTAL
Real number (ℝ≥0)

ZEROS

Distinct count13
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.17885227292778036
Minimum0.0
Maximum13.0
Zeros147605
Zeros (%)86.8%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile1
Maximum13
Range13
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.5395852213
Coefficient of variation (CV)3.016932424
Kurtosis31.08309577
Mean0.1788522729
Median Absolute Deviation (MAD)0
Skewness4.473596523
Sum30409
Variance0.2911522111
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
014760586.8%
 
11706310.0%
 
236792.2%
 
310960.6%
 
43570.2%
 
51380.1%
 
647< 0.1%
 
722< 0.1%
 
88< 0.1%
 
93< 0.1%
 
Other values (3)5< 0.1%
 
ValueCountFrequency (%) 
014760586.8%
 
11706310.0%
 
236792.2%
 
310960.6%
 
43570.2%
 
ValueCountFrequency (%) 
131< 0.1%
 
112< 0.1%
 
102< 0.1%
 
93< 0.1%
 
88< 0.1%
 

INJURIES_FATAL
Categorical

Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
0
169936
1
 
82
2
 
4
3
 
1
ValueCountFrequency (%) 
016993699.9%
 
182< 0.1%
 
24< 0.1%
 
31< 0.1%
 

Length

Max length3
Median length3
Mean length3
Min length3

INJURIES_INCAPACITATING
Real number (ℝ≥0)

ZEROS

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.018891561729883603
Minimum0.0
Maximum5.0
Zeros167295
Zeros (%)98.4%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum5
Range5
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.1619503063
Coefficient of variation (CV)8.572626689
Kurtosis173.3193565
Mean0.01889156173
Median Absolute Deviation (MAD)0
Skewness11.30760395
Sum3212
Variance0.02622790171
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
016729598.4%
 
123751.4%
 
22560.2%
 
368< 0.1%
 
424< 0.1%
 
55< 0.1%
 
ValueCountFrequency (%) 
016729598.4%
 
123751.4%
 
22560.2%
 
368< 0.1%
 
424< 0.1%
 
ValueCountFrequency (%) 
55< 0.1%
 
424< 0.1%
 
368< 0.1%
 
22560.2%
 
123751.4%
 

INJURIES_NON_INCAPACITATING
Real number (ℝ≥0)

ZEROS

Distinct count11
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.09533416067237963
Minimum0.0
Maximum11.0
Zeros157578
Zeros (%)92.7%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile1
Maximum11
Range11
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.3921160241
Coefficient of variation (CV)4.113069453
Kurtosis58.02302948
Mean0.09533416067
Median Absolute Deviation (MAD)0
Skewness6.119044588
Sum16209
Variance0.1537549764
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
015757892.7%
 
199065.8%
 
217581.0%
 
35070.3%
 
41770.1%
 
557< 0.1%
 
622< 0.1%
 
711< 0.1%
 
84< 0.1%
 
112< 0.1%
 
ValueCountFrequency (%) 
015757892.7%
 
199065.8%
 
217581.0%
 
35070.3%
 
41770.1%
 
ValueCountFrequency (%) 
112< 0.1%
 
101< 0.1%
 
84< 0.1%
 
711< 0.1%
 
622< 0.1%
 

INJURIES_REPORTED_NOT_EVIDENT
Real number (ℝ≥0)

ZEROS

Distinct count11
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.06407956570581627
Minimum0.0
Maximum10.0
Zeros161617
Zeros (%)95.1%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum10
Range10
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.3201525205
Coefficient of variation (CV)4.996171821
Kurtosis75.43556623
Mean0.06407956571
Median Absolute Deviation (MAD)0
Skewness7.137627663
Sum10895
Variance0.1024976364
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
016161795.1%
 
166473.9%
 
212750.7%
 
33300.2%
 
4940.1%
 
543< 0.1%
 
69< 0.1%
 
74< 0.1%
 
82< 0.1%
 
91< 0.1%
 
ValueCountFrequency (%) 
016161795.1%
 
166473.9%
 
212750.7%
 
33300.2%
 
4940.1%
 
ValueCountFrequency (%) 
101< 0.1%
 
91< 0.1%
 
82< 0.1%
 
74< 0.1%
 
69< 0.1%
 

INJURIES_NO_INDICATION
Real number (ℝ≥0)

ZEROS

Distinct count19
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.1724119677925926
Minimum0.0
Maximum19.0
Zeros2783
Zeros (%)1.6%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile1
Q12
median2
Q32
95-th percentile4
Maximum19
Range19
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.107867356
Coefficient of variation (CV)0.5099711163
Kurtosis10.11862197
Mean2.172411968
Median Absolute Deviation (MAD)0
Skewness2.054233066
Sum369360
Variance1.227370079
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
29272654.5%
 
13373419.8%
 
32480714.6%
 
493055.5%
 
538462.3%
 
027831.6%
 
616411.0%
 
76400.4%
 
82800.2%
 
91180.1%
 
Other values (9)1430.1%
 
ValueCountFrequency (%) 
027831.6%
 
13373419.8%
 
29272654.5%
 
32480714.6%
 
493055.5%
 
ValueCountFrequency (%) 
191< 0.1%
 
174< 0.1%
 
168< 0.1%
 
154< 0.1%
 
1412< 0.1%
 

CRASH_HOUR
Real number (ℝ≥0)

ZEROS

Distinct count24
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.280756132993771
Minimum0.0
Maximum23.0
Zeros2664
Zeros (%)1.6%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile4
Q19
median14
Q317
95-th percentile21
Maximum23
Range23
Interquartile range (IQR)8

Descriptive statistics

Standard deviation5.257633647
Coefficient of variation (CV)0.3958836074
Kurtosis-0.347998741
Mean13.28075613
Median Absolute Deviation (MAD)4
Skewness-0.3704724486
Sum2258034
Variance27.64271157
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
16136228.0%
 
15135027.9%
 
17132477.8%
 
14118046.9%
 
18106416.3%
 
13104956.2%
 
8104456.1%
 
1299325.8%
 
1187795.2%
 
785035.0%
 
Other values (14)5905334.7%
 
ValueCountFrequency (%) 
026641.6%
 
121481.3%
 
219321.1%
 
315630.9%
 
414900.9%
 
ValueCountFrequency (%) 
2337472.2%
 
2245852.7%
 
2151163.0%
 
2058543.4%
 
1974774.4%
 

CRASH_DAY_OF_WEEK
Real number (ℝ≥0)

Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.143574692835675
Minimum1.0
Maximum7.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q36
95-th percentile7
Maximum7
Range6
Interquartile range (IQR)4

Descriptive statistics

Standard deviation1.943718512
Coefficient of variation (CV)0.4690921864
Kurtosis-1.20505114
Mean4.143574693
Median Absolute Deviation (MAD)2
Skewness-0.08342100232
Sum704503
Variance3.778041654
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
62809116.5%
 
52524714.8%
 
42491114.7%
 
32490414.6%
 
72413314.2%
 
22369813.9%
 
11903911.2%
 
ValueCountFrequency (%) 
11903911.2%
 
22369813.9%
 
32490414.6%
 
42491114.7%
 
52524714.8%
 
ValueCountFrequency (%) 
72413314.2%
 
62809116.5%
 
52524714.8%
 
42491114.7%
 
32490414.6%
 

CRASH_MONTH
Real number (ℝ≥0)

Distinct count12
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.630979338089553
Minimum1.0
Maximum12.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1
5-th percentile1
Q14
median7
Q310
95-th percentile12
Maximum12
Range11
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.497311421
Coefficient of variation (CV)0.527420045
Kurtosis-1.249054291
Mean6.630979338
Median Absolute Deviation (MAD)3
Skewness-0.04830946728
Sum1127419
Variance12.23118717
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10158149.3%
 
12155319.1%
 
11150508.9%
 
5148078.7%
 
9143958.5%
 
1141498.3%
 
3137828.1%
 
6137128.1%
 
8136168.0%
 
2136028.0%
 
Other values (2)2556515.0%
 
ValueCountFrequency (%) 
1141498.3%
 
2136028.0%
 
3137828.1%
 
4130297.7%
 
5148078.7%
 
ValueCountFrequency (%) 
12155319.1%
 
11150508.9%
 
10158149.3%
 
9143958.5%
 
8136168.0%
 

LATITUDE
Real number (ℝ≥0)

HIGH CORRELATION
SKEWED

Distinct count93791
Unique (%)55.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean41.85832423734304
Minimum0.0
Maximum42.022779861
Zeros17
Zeros (%)< 0.1%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile41.71524485
Q141.78958119
median41.87944196
Q341.92768648
95-th percentile41.99054486
Maximum42.02277986
Range42.02277986
Interquartile range (IQR)0.138105291

Descriptive statistics

Standard deviation0.4271946112
Coefficient of variation (CV)0.01020572656
Kurtosis9213.872316
Mean41.85832424
Median Absolute Deviation (MAD)0.066371257
Skewness-94.06388966
Sum7116877.862
Variance0.1824952359
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
41.976201142120.1%
 
41.75146061120.1%
 
41.900958921080.1%
 
41.791420281070.1%
 
41.7222572785< 0.1%
 
41.9010028674< 0.1%
 
41.7893293274< 0.1%
 
41.7546601270< 0.1%
 
41.7362094767< 0.1%
 
41.7929108865< 0.1%
 
Other values (93781)16904999.4%
 
ValueCountFrequency (%) 
017< 0.1%
 
41.644670134< 0.1%
 
41.644693972< 0.1%
 
41.644715441< 0.1%
 
41.644718771< 0.1%
 
ValueCountFrequency (%) 
42.022779862< 0.1%
 
42.022661142< 0.1%
 
42.022645141< 0.1%
 
42.022641681< 0.1%
 
42.022551321< 0.1%
 

LONGITUDE
Real number (ℝ)

HIGH CORRELATION
SKEWED

Distinct count93787
Unique (%)55.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-87.67070524713213
Minimum-87.934014222
Maximum0.0
Zeros17
Zeros (%)< 0.1%
Memory size1.3 MiB

Quantile statistics

Minimum-87.93401422
5-th percentile-87.78188205
Q1-87.72230714
median-87.67272966
Q3-87.63315544
95-th percentile-87.58762602
Maximum0
Range87.93401422
Interquartile range (IQR)0.089151695

Descriptive statistics

Standard deviation0.8786550779
Coefficient of variation (CV)-0.0100222198
Kurtosis9907.679574
Mean-87.67070525
Median Absolute Deviation (MAD)0.042582218
Skewness99.32443394
Sum-14906036.32
Variance0.7720347459
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
-87.905309132120.1%
 
-87.585971991120.1%
 
-87.619928171080.1%
 
-87.580147771070.1%
 
-87.5852755785< 0.1%
 
-87.7416456474< 0.1%
 
-87.6197798174< 0.1%
 
-87.7413847670< 0.1%
 
-87.6243055267< 0.1%
 
-87.7420773465< 0.1%
 
Other values (93777)16904999.4%
 
ValueCountFrequency (%) 
-87.934014221< 0.1%
 
-87.9339939310< 0.1%
 
-87.933028282< 0.1%
 
-87.927261682< 0.1%
 
-87.925035621< 0.1%
 
ValueCountFrequency (%) 
017< 0.1%
 
-87.524587391< 0.1%
 
-87.524589011< 0.1%
 
-87.524640321< 0.1%
 
-87.524673952< 0.1%
 

STREET_TYPE
Categorical

Distinct count15
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
AVE
85561
ST
51625
RD
 
11639
DR
 
6561
BLVD
 
6163
Other values (10)
 
8474
ValueCountFrequency (%) 
AVE8556150.3%
 
ST5162530.4%
 
RD116396.8%
 
DR65613.9%
 
BLVD61633.6%
 
NB15560.9%
 
SB14840.9%
 
PL13000.8%
 
PKWY12020.7%
 
BROADWAY9330.5%
 
Other values (5)19991.2%
 

Length

Max length8
Median length3
Mean length2.631173429
Min length1
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
0
88229
1
81794
ValueCountFrequency (%) 
08822951.9%
 
18179448.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
1
168234
0
 
1789
ValueCountFrequency (%) 
116823498.9%
 
017891.1%
 

LEVEL_ROAD
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
1
166678
0
 
3345
ValueCountFrequency (%) 
116667898.0%
 
033452.0%
 

TIME_BEFORE_NOTIFICATION
Real number (ℝ≥0)

Distinct count1179
Unique (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean93.18010504461161
Minimum2.0000000000000004
Maximum1182.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum2
5-th percentile2
Q19
median28
Q369
95-th percentile550
Maximum1182
Range1180
Interquartile range (IQR)60

Descriptive statistics

Standard deviation196.7186373
Coefficient of variation (CV)2.111165652
Kurtosis12.82761221
Mean93.18010504
Median Absolute Deviation (MAD)23
Skewness3.551872939
Sum15842761
Variance38698.22225
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5122597.2%
 
288995.2%
 
1075904.5%
 
3075104.4%
 
1572734.3%
 
366823.9%
 
2061003.6%
 
454903.2%
 
2542252.5%
 
6038682.3%
 
Other values (1169)10012758.9%
 
ValueCountFrequency (%) 
288995.2%
 
366823.9%
 
454903.2%
 
5122597.2%
 
636342.1%
 
ValueCountFrequency (%) 
11828< 0.1%
 
11815< 0.1%
 
118052< 0.1%
 
11791< 0.1%
 
11789< 0.1%
 

LANE_TYPE
Categorical

MISSING

Distinct count4
Unique (%)< 0.1%
Missing81976
Missing (%)48.2%
Memory size166.2 KiB
small
51328
medium
29712
large
 
3538
intersection
 
3469
ValueCountFrequency (%) 
small5132830.2%
 
medium2971217.5%
 
large35382.1%
 
intersection34692.0%
 
(Missing)8197648.2%
 

Length

Max length12
Median length5
Mean length4.353281615
Min length3

MAIN_CAUSE
Categorical

HIGH CORRELATION

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
Driver Error
152302
Weather
 
5003
Driver/Equip/RD Health
 
4546
Driver Distraction
 
4230
Road/Vision Obstruction
 
2597
ValueCountFrequency (%) 
Driver Error15230289.6%
 
Weather50032.9%
 
Driver/Equip/RD Health45462.7%
 
Driver Distraction42302.5%
 
Road/Vision Obstruction25971.5%
 
Drug Use13450.8%
 

Length

Max length23
Median length12
Mean length12.40589803
Min length7

TOTAL_PEOPLE_INVOLVED
Real number (ℝ≥0)

Distinct count19
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.351264240720373
Minimum1.0
Maximum19.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum1
5-th percentile1
Q12
median2
Q33
95-th percentile4
Maximum19
Range18
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.116056721
Coefficient of variation (CV)0.4746623974
Kurtosis11.08803208
Mean2.351264241
Median Absolute Deviation (MAD)0
Skewness2.357585749
Sum399769
Variance1.245582605
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
29904558.3%
 
32836016.7%
 
12302213.5%
 
4111616.6%
 
547762.8%
 
621001.2%
 
78550.5%
 
83620.2%
 
91560.1%
 
1077< 0.1%
 
Other values (9)1090.1%
 
ValueCountFrequency (%) 
12302213.5%
 
29904558.3%
 
32836016.7%
 
4111616.6%
 
547762.8%
 
ValueCountFrequency (%) 
191< 0.1%
 
181< 0.1%
 
174< 0.1%
 
168< 0.1%
 
154< 0.1%
 

DRY_ROAD
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
1
128493
0
41530
ValueCountFrequency (%) 
112849375.6%
 
04153024.4%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
1
135513
0
34510
ValueCountFrequency (%) 
113551379.7%
 
03451020.3%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
1
152302
0
 
17721
ValueCountFrequency (%) 
115230289.6%
 
01772110.4%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

df_indexCRASH_RECORD_IDRD_NOPOSTED_SPEED_LIMITTRAFFIC_CONTROL_DEVICEDEVICE_CONDITIONWEATHER_CONDITIONLIGHTING_CONDITIONFIRST_CRASH_TYPETRAFFICWAY_TYPEROADWAY_SURFACE_CONDROAD_DEFECTREPORT_TYPECRASH_TYPEHIT_AND_RUN_IDAMAGEPRIM_CONTRIBUTORY_CAUSESEC_CONTRIBUTORY_CAUSESTREET_NOSTREET_DIRECTIONSTREET_NAMEBEAT_OF_OCCURRENCENUM_UNITSINJURIES_TOTALINJURIES_FATALINJURIES_INCAPACITATINGINJURIES_NON_INCAPACITATINGINJURIES_REPORTED_NOT_EVIDENTINJURIES_NO_INDICATIONCRASH_HOURCRASH_DAY_OF_WEEKCRASH_MONTHLATITUDELONGITUDESTREET_TYPETRAFFIC_CONTROL_PRESENTSTRAIGHT_ROADLEVEL_ROADTIME_BEFORE_NOTIFICATIONLANE_TYPEMAIN_CAUSETOTAL_PEOPLE_INVOLVEDDRY_ROADCLEAR_WEATHERDRIVER_ERROR
060209e21f298984f7375742b7ef27c9880b485f41123a12b5a8eb14f01171abbbc05974399b985e05a352f801869cae0f41587f39a51994338fb82aeba853eeceJB41543630.0TRAFFIC SIGNALFUNCTIONING PROPERLYCLEARDAYLIGHTTURNINGNOT DIVIDEDDRYUNKNOWNNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0OVER $1,500IMPROPER OVERTAKING/PASSINGIMPROPER LANE USAGE600.0WDIVISION ST1822.02.00.00.00.00.00.02.017.05.08.041.903825-87.643286ST1.01.01.013.0NaNDriver Error2.0111
1802e2ed3606a50dda185f5e97c57a45552087d6fbea1c4b5f3777e0503da72279211f0518aabbeca2cd8e8ee1aca6cae3f88a0531cb62bb39ac156ca3d55e0931JB25639325.0NO CONTROLSNO CONTROLSRAINDAYLIGHTANGLENOT DIVIDEDWETNO DEFECTSON SCENENO INJURY / DRIVE AWAY0.0OVER $1,500FAILING TO YIELD RIGHT-OF-WAYUNABLE TO DETERMINE9511.0SWENTWORTH AVE511.02.00.00.00.00.00.02.011.04.05.041.721290-87.628510AVE0.01.01.05.0smallDriver Error2.0001
211046c0f96fdf5f7384e026821bb23fdd56d610dce11247b4cf7072f4e0308cdf5865ee8f31d71792ef005d864c064aae933213ef5e4e87a9bb2247ffe0f56f245JC12822630.0NO CONTROLSNO CONTROLSCLEARDARKNESS, LIGHTED ROADREAR ENDDIVIDED - W/MEDIAN BARRIERWETNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0OVER $1,500EXCEEDING SAFE SPEED FOR CONDITIONSFOLLOWING TOO CLOSELY50.0EGARFIELD BLVD225.02.00.00.00.00.00.02.06.05.01.041.794779-87.623828BLVD0.01.01.0535.0mediumDriver Error2.0011
31204f6245394966ed41b109ac46b18ed45b8b90c6607cebc99008d9a733b4b668d4effab8de602f2ed17854835b5efce5d76701c8d97d25c23c9814ee9e63e7a60JB25851630.0STOP SIGN/FLASHERFUNCTIONING PROPERLYCLEARDAYLIGHTREAR ENDONE-WAYDRYNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY1.0$501 - $1,500IMPROPER BACKINGNOT APPLICABLE180.0WSCHILLER ST1821.02.00.00.00.00.00.03.018.05.05.041.907777-87.634531ST1.01.01.040.0smallDriver Error3.0111
4130564e565ebda939c88d5da6d613ac5789b702cbff5b8744552f9930bd571995afb81a895dfd2bc8a23e6cca53f8fc6a9afbeb38591781281a3c37ceba5cbcbd5JC54193620.0TRAFFIC SIGNALFUNCTIONING PROPERLYCLEARDAYLIGHTPEDESTRIANNOT DIVIDEDDRYNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0$500 OR LESSDISTRACTION - FROM INSIDE VEHICLEDISTRACTION - FROM INSIDE VEHICLE3998.0NASHLAND AVE1922.02.00.00.00.00.00.02.015.03.012.041.954196-87.669193AVE1.01.01.05.0NaNDriver Distraction2.0110
51405a2558531eb0174cb4d8ec5de92fdc94c1894b31923fdbb09f62e41a1eb3716ca641b84c64b6b5dd442cd4f1214eb061318d37154d66d03fb59056987645db7JA11698830.0NO CONTROLSNO CONTROLSCLEARDAYLIGHTSIDESWIPE SAME DIRECTIONDIVIDED - W/MEDIAN (NOT RAISED)DRYNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0OVER $1,500IMPROPER LANE USAGENOT APPLICABLE117.0WNORTH AVE1821.02.00.00.00.00.00.04.014.01.01.041.911051-87.632436AVE0.01.01.020.0mediumDriver Error4.0111
615064e66979a2970426924a31edac09282c4ede65aad5827ab5bf314b0c5404ddb82dfd349d1df97f7cdd42fa48054021295a7b5b9f873cf77a8ae5b506516ba24JA16288730.0TRAFFIC SIGNALFUNCTIONING PROPERLYCLOUDY/OVERCASTDAYLIGHTTURNINGDIVIDED - W/MEDIAN (NOT RAISED)WETNO DEFECTSON SCENENO INJURY / DRIVE AWAY0.0OVER $1,500IMPROPER OVERTAKING/PASSINGFAILING TO REDUCE SPEED TO AVOID CRASH2101.0SASHLAND AVE1235.02.00.00.00.00.00.03.07.04.02.041.854120-87.665902AVE1.01.01.04.0intersectionDriver Error3.0001
7180715747ad03659bf4f8c41699d349d805c0a8863e7033c7f0dd4b6232d2ab96f5c7d161d9f944f4919f1d16520d6f9ebe8fe3d9175212d0f011ee4bf9137b38eHZ48530730.0STOP SIGN/FLASHERFUNCTIONING PROPERLYCLEARDARKNESS, LIGHTED ROADANGLENOT DIVIDEDDRYNO DEFECTSON SCENENO INJURY / DRIVE AWAY0.0OVER $1,500FAILING TO YIELD RIGHT-OF-WAYDISREGARDING STOP SIGN2000.0WERIE ST1221.02.00.00.00.00.00.03.03.01.010.041.893281-87.677100ST1.01.01.03.0smallDriver Error3.0111
82007cf8b845534957256f1c0dafd4f95c08037233f3d367db726f9f56686ec31ce7bc3f24e350ae9d93cde2387a6606093775ac87dfb78685050e5ef0f096f67c9JB23703130.0TRAFFIC SIGNALFUNCTIONING PROPERLYCLEARDAYLIGHTREAR ENDNOT DIVIDEDDRYNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0OVER $1,500FOLLOWING TOO CLOSELYDRIVING SKILLS/KNOWLEDGE/EXPERIENCE11.0SAUSTIN BLVD1513.02.00.00.00.00.00.02.018.03.04.041.879714-87.774496BLVD1.01.01.0800.0NaNDriver Error2.0111
921097eb95ff3e26f44b8ae8f38890128a3ca6158d1cd41f5a3fcb2491b1cac2eb87ad2d281f493e3200223480a6cfbe09e014466bb06428a512ffbd3c84c42d677JA45498230.0OTHERNO CONTROLSCLEARDAYLIGHTSIDESWIPE SAME DIRECTIONNOT DIVIDEDDRYNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0OVER $1,500IMPROPER LANE USAGENOT APPLICABLE9505.0SHALSTED ST2223.02.00.00.00.00.00.02.08.02.010.041.721256-87.643062ST1.01.01.095.0NaNDriver Error2.0111

Last rows

df_indexCRASH_RECORD_IDRD_NOPOSTED_SPEED_LIMITTRAFFIC_CONTROL_DEVICEDEVICE_CONDITIONWEATHER_CONDITIONLIGHTING_CONDITIONFIRST_CRASH_TYPETRAFFICWAY_TYPEROADWAY_SURFACE_CONDROAD_DEFECTREPORT_TYPECRASH_TYPEHIT_AND_RUN_IDAMAGEPRIM_CONTRIBUTORY_CAUSESEC_CONTRIBUTORY_CAUSESTREET_NOSTREET_DIRECTIONSTREET_NAMEBEAT_OF_OCCURRENCENUM_UNITSINJURIES_TOTALINJURIES_FATALINJURIES_INCAPACITATINGINJURIES_NON_INCAPACITATINGINJURIES_REPORTED_NOT_EVIDENTINJURIES_NO_INDICATIONCRASH_HOURCRASH_DAY_OF_WEEKCRASH_MONTHLATITUDELONGITUDESTREET_TYPETRAFFIC_CONTROL_PRESENTSTRAIGHT_ROADLEVEL_ROADTIME_BEFORE_NOTIFICATIONLANE_TYPEMAIN_CAUSETOTAL_PEOPLE_INVOLVEDDRY_ROADCLEAR_WEATHERDRIVER_ERROR
1700134161701a3386e6a23e96e01acff8acf0ef1b3e7356197c38e2422162e1d6f75c508a39d017a5d6248b4172c02a935c7e64f540a1e9c2432b67c86e9f795f64f3eff849JD23684630.0NO CONTROLSNO CONTROLSCLEARDAYLIGHTTURNINGNOT DIVIDEDWETUNKNOWNON SCENENO INJURY / DRIVE AWAY1.0OVER $1,500FAILING TO YIELD RIGHT-OF-WAYNOT APPLICABLE2718.0WFOSTER AVE2011.02.00.00.00.00.00.03.016.03.05.041.975941-87.697289AVE0.01.01.010.0NaNDriver Error3.0011
17001441617216acabdfcfa055f2e7760b288b67d37c4b2f8564d1eaa1b08abd5de7707e5c56cb5c06fd9034d3492ff2c81bc0ee07bdcff61771b03b2948689c153041c278acJD23641725.0NO CONTROLSNO CONTROLSRAINDARKNESS, LIGHTED ROADSIDESWIPE SAME DIRECTIONNOT DIVIDEDWETNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY1.0$501 - $1,500IMPROPER LANE USAGENOT APPLICABLE7159.0SNORMAL BLVD732.02.00.00.00.00.00.02.00.03.05.041.763587-87.636913BLVD0.01.01.0570.0NaNDriver Error2.0001
170015416173001eecabb8448be837995caca46a221c62245ece1ad580ef77e572be61a030bb614fb67f69f0add17e5e043d4034a88b1cca656c0de307853e7cae281e222a8cJD23672030.0NO CONTROLSNO CONTROLSFOG/SMOKE/HAZEDAYLIGHTREAR ENDNOT DIVIDEDWETNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0$501 - $1,500FOLLOWING TOO CLOSELYFAILING TO REDUCE SPEED TO AVOID CRASH2159.0NHARLEM AVE2512.02.00.00.00.00.00.02.014.03.05.041.919767-87.805972AVE0.01.01.061.0NaNDriver Error2.0001
1700164161740c3ec565fd94621168dccbfd0a95097d0d96ab27241bfee94e818ce7a02c812e70f3ec53d4565670b568ab56ea4a9d6a8d88e18820ec5185f00f004f42147d37JD23682730.0NO CONTROLSNO CONTROLSCLEARDAYLIGHTSIDESWIPE SAME DIRECTIONNOT DIVIDEDDRYNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0$501 - $1,500FOLLOWING TOO CLOSELYNOT APPLICABLE500.0SCENTRAL AVE1513.02.00.00.00.00.00.02.016.03.05.041.873773-87.764770AVE0.01.01.020.0NaNDriver Error2.0111
170017416182ee451349ec959d73cb77c87e2bcfda6bbd378bcd74421660d3c204762dba12bd6a0738c90289e441e6b804060f61a1e4e434a6d62c047308fa3346afc324e2c7JD23677625.0TRAFFIC SIGNALFUNCTIONING PROPERLYCLEARDAYLIGHTANGLEFOUR WAYWETNO DEFECTSON SCENENO INJURY / DRIVE AWAY1.0OVER $1,500DISREGARDING TRAFFIC SIGNALSUNABLE TO DETERMINE5032.0NCLARK ST2032.02.00.00.00.00.00.02.014.03.05.041.973359-87.668224ST1.01.01.05.0NaNDriver Error2.0011
170018416184e450bca25335c1278ea2363381ecc508ebd53e5c56674707122b665be54927fd0c49eebe9d98a1f14a95983f1933e726b107399f9436754191e6e1def6e90535JD23500630.0NO CONTROLSNO CONTROLSRAINDAWNPARKED MOTOR VEHICLEDIVIDED - W/MEDIAN (NOT RAISED)WETNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0OVER $1,500IMPROPER BACKINGNOT APPLICABLE3604.0NCENTRAL PARK AVE1732.02.00.00.00.00.00.01.013.01.05.041.947062-87.717972AVE0.01.01.052.0NaNDriver Error1.0001
170019416185d0a818ec05c4314c5f56b82c0590fd98686aeaf01e04756cabb424d171534fbf8adaa91a7560832d82dc0b733466568c498bc900022a3429990bcb190ab51509JD23537330.0NO CONTROLSNO CONTROLSCLEARDARKNESS, LIGHTED ROADPARKED MOTOR VEHICLENOT DIVIDEDDRYNO DEFECTSON SCENEINJURY AND / OR TOW DUE TO CRASH0.0OVER $1,500DISTRACTION - FROM OUTSIDE VEHICLEDISTRACTION - FROM OUTSIDE VEHICLE6747.0WBELMONT AVE2511.02.00.00.00.00.00.01.00.02.05.041.938057-87.795161AVE0.01.01.02.0NaNDriver Distraction1.0110
170020416187dba8fb67b8cfd7b0d1da3b9f03eccf574edd2835101419c4cbfa728e9d75673d138879354351927fb5fafcd6210bf19c503f66c9e0644a61ece7c333c0bf44eaJD23677030.0TRAFFIC SIGNALFUNCTIONING PROPERLYCLEARDAYLIGHTSIDESWIPE SAME DIRECTIONNOT DIVIDEDDRYNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0OVER $1,500IMPROPER LANE USAGENOT APPLICABLE1440.0NASHLAND AVE1433.02.00.00.00.00.00.02.014.03.05.041.908249-87.667768AVE1.01.01.045.0NaNDriver Error2.0111
170021416191d97477e587b8eecbdb0dbce0a0c5462e7335a4f7da2e04c8e4799193cba69f0b887de56a831e8899031c1f7175e82a2ad8c43ba34260181a3e4e1bafda37ea88JD23402740.0NO CONTROLSNO CONTROLSCLEARDAYLIGHTSIDESWIPE SAME DIRECTIONDIVIDED - W/MEDIAN BARRIERDRYNO DEFECTSON SCENEINJURY AND / OR TOW DUE TO CRASH0.0OVER $1,500FAILING TO YIELD RIGHT-OF-WAYNOT APPLICABLE120.0NLAKE SHORE DR SB114.02.00.00.00.00.00.02.011.07.05.041.883642-87.615441SB0.00.01.010.0NaNDriver Error2.0111
170022416193de4cbde297443228427759c6d58f40254dc8d8fcb201dc731da85d4d0dcd05fd2fbb10974bc0d17cdecd4128959af5b2fc2a4b8a0ee42f3370be201aba68a5bdJD23565110.0NO CONTROLSNO CONTROLSCLEARDAYLIGHTREAR TO SIDEPARKING LOTDRYNO DEFECTSNOT ON SCENE (DESK REPORT)NO INJURY / DRIVE AWAY0.0$500 OR LESSFAILING TO YIELD RIGHT-OF-WAYUNABLE TO DETERMINE1527.0WLAWRENCE AVE1912.02.00.00.00.00.00.02.012.02.05.041.968773-87.668624AVE0.01.01.012.0NaNDriver Error2.0111